SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DnnProduct_CDS_DistributionLogGet]
	@ID int,
	@DistributorID varchar(50)
AS
BEGIN
	SELECT D.[ID], D.AssetID, D.EntryDate, D.Username, D.ResponseStatus, D.Data
	FROM [DnnProduct_CDS_DistributionLog] D
	JOIN [DnnProduct_CDS_Assets] A ON D.AssetID = A.[ID]
	WHERE D.[ID] = @ID AND A.DistributorID = @DistributorID
END
GO
